UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4HMofB5NePZZ9JbhTCsY+KzVyatbwVPYe4QVR+9I6Do='
WHERE
key_id = '0a537916b5dcfa404dd16b2ae5eba399d19d34dedd88745825d86bf0510fc653'
AND (
token = '4HMofB5NePZZ9JbhTCsY+KzVyatbwVPYe4QVR+9I6Do='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)