UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Do30tQkwQJ8PhdzbrSaJwCfDSErQj3AVNsAbyw7/Leo='
WHERE
key_id = 'c319b78e1707a4b291b5fe859f3d00d2229755c1a3fb17f23b173914ad14cb74'
AND (
token = 'Do30tQkwQJ8PhdzbrSaJwCfDSErQj3AVNsAbyw7/Leo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)