UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Y8OwsescqdE1dx9IQrHGIiinQ/jIjnFSI1rYPROtt1o='
WHERE
key_id = '3d9fc1e7c99821495e82d416ceefe4068cc5f1f29fb66bad270a59b6d8a5169d'
AND (
token = 'Y8OwsescqdE1dx9IQrHGIiinQ/jIjnFSI1rYPROtt1o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)