UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ISNyJT4zi03WIqG7lmW0R9fgYLdC5BLDLJdBjBvkmLs='
WHERE
key_id = '9d1e9e2e20571bd92e5a310028fb450270c2ddb8629e2386345381c635831c8f'
AND (
token = 'ISNyJT4zi03WIqG7lmW0R9fgYLdC5BLDLJdBjBvkmLs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)