UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oD2E4QBBrC9LNHEHr4I2Jsg1nl8AdClErIEtzvaZVjw='
WHERE
key_id = '5f16170760e4dddbb0e17272e79816aa2230de779a49045e217e567b6a9a0ab5'
AND (
token = 'oD2E4QBBrC9LNHEHr4I2Jsg1nl8AdClErIEtzvaZVjw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)