UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gSVgj3oZFLZ8p894JUCBkvmPhnOCdzOgDW6FbI6QTNA='
WHERE
key_id = '1d2dd2ddabc652b4c16240ad6e901b5c78d1607f458a6fa11020ad10c1d9b3ca'
AND (
token = 'gSVgj3oZFLZ8p894JUCBkvmPhnOCdzOgDW6FbI6QTNA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)