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