UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1Dh9bmOJ6hZZ8dxzUfSkcF2abA+B9wVeDT5ngtu+Zrs='
WHERE
key_id = '241894f019d8094edbcc17d807aa4d22024664a6d5ed607822200dcb72b2ef2a'
AND (
token = '1Dh9bmOJ6hZZ8dxzUfSkcF2abA+B9wVeDT5ngtu+Zrs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)