UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cUlTnRLKIla+9JsBVdcfnb6qFqLo9w5D42UfcTu9uVA='
WHERE
key_id = 'a72b0b8aa6054542b67cefc80e7235cd16b926e7d4a6cd2554405b291eb4123b'
AND (
token = 'cUlTnRLKIla+9JsBVdcfnb6qFqLo9w5D42UfcTu9uVA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)