UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o3XybRZD9a5pKUQXwn6p7exaUPGoedJ8Hfrl9XBg9xI='
WHERE
key_id = '6c4705edc58ac4b2aa56e6f46618916ccd836bab9ade8839a3dbf152b5ed6dc2'
AND (
token = 'o3XybRZD9a5pKUQXwn6p7exaUPGoedJ8Hfrl9XBg9xI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)