UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8An3geeJKPqQ0EDuv1N+xdgnPbQc1MzGtSfP0D46/So='
WHERE
key_id = 'fa9244df84ce9b99ff517467223ad98c2a4f273d9c9019bdc4ab36bc8c8a7641'
AND (
token = '8An3geeJKPqQ0EDuv1N+xdgnPbQc1MzGtSfP0D46/So='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)