UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zDIf2gNbZkqJPNnmA6FmPvgbJubHdaiMeLiSj8kHiZI='
WHERE
key_id = 'cf810d4a929b3748746fa9b28a4ef3b67ff99f4d6d16400f65f45703f4861ccd'
AND (
token = 'zDIf2gNbZkqJPNnmA6FmPvgbJubHdaiMeLiSj8kHiZI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)