UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4jHDdXEf6dX6OWfj6wTmliC9Hgw+ftNC+bmmtqxvYGc='
WHERE
key_id = '8c665471fa6f66f7731360b676686f4fda934f6cf007ec5d2494ef908035c231'
AND (
token = '4jHDdXEf6dX6OWfj6wTmliC9Hgw+ftNC+bmmtqxvYGc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)