UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9E+8n8baVVIqJwcpt3ne0zFHHvSqjY7iBw5blRDUD/o='
WHERE
key_id = 'a4035c6756e81cacef333e84421c0de7cfe6698f0ab50123c291d4b875edf948'
AND (
token = '9E+8n8baVVIqJwcpt3ne0zFHHvSqjY7iBw5blRDUD/o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)