UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BVKYzxGz9LohLbDD8wLTevDauKPIAEvTSqJRwGLe7S0='
WHERE
key_id = '9057b502ec74203807d3f01295da75b7d2c0016b3e04fa522f52c052ba164129'
AND (
token = 'BVKYzxGz9LohLbDD8wLTevDauKPIAEvTSqJRwGLe7S0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)