UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KUZmG7F2Yii4w8H6eITythzbsTAWSG2eAAPxaRhK4fM='
WHERE
key_id = '50b1264cbbe89a49e4669381f79e84b23333d816072c129ba0b58eceaf4e629b'
AND (
token = 'KUZmG7F2Yii4w8H6eITythzbsTAWSG2eAAPxaRhK4fM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)