UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iiXwZmD2cRIhbq1Vo2tN58ibi87Al4CKD4hOIkgQufI='
WHERE
key_id = '781c1caab840f4cd647f715cf1dd49197ce3b74429e0a9a7cad1c0c91c549517'
AND (
token = 'iiXwZmD2cRIhbq1Vo2tN58ibi87Al4CKD4hOIkgQufI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)