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