UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FHHHW/TmdMVBlqS8nqGlcQYkHEoRh2KXW9HeRVek5SU='
WHERE
key_id = '6efd670891890563d09496955595e8668bd7296b9e9da5b2ee9707fc30a154a9'
AND (
token = 'FHHHW/TmdMVBlqS8nqGlcQYkHEoRh2KXW9HeRVek5SU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)