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