UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+mXj4H9jWd+fd43ygv5kmLxcuXsXMDffKB87gWAALRk='
WHERE
key_id = '300a1de65df496065e3c54b58330efb888e84adcb0a5e29a887dd710a576da39'
AND (
token = '+mXj4H9jWd+fd43ygv5kmLxcuXsXMDffKB87gWAALRk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)