UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rts6I+Yh9oJuiLXN0YGjoQ1qrq/LllHVDGxKGjnJGj8='
WHERE
key_id = 'c1b658760a6a8eec2678157f23b277027d2ff0d4621906320aaba35558f5f242'
AND (
token = 'rts6I+Yh9oJuiLXN0YGjoQ1qrq/LllHVDGxKGjnJGj8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)