UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9A338m3uBYM+KsLIKy7/xpSKp1SBBSDGQ6A7WykMsBA='
WHERE
key_id = '4b8bda765d6e603d8bf17bfa4416b4055b7e5f0e7bc0571f9e84999cd426a246'
AND (
token = '9A338m3uBYM+KsLIKy7/xpSKp1SBBSDGQ6A7WykMsBA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)