UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lZgGUKasrI4BDw9gR097rwplu/lJpIh2cO+fuhTk0n8='
WHERE
key_id = 'd6d1f98b2bbbad7e841125e759e923354e82c75dc0db046c80364ba7346059fd'
AND (
token = 'lZgGUKasrI4BDw9gR097rwplu/lJpIh2cO+fuhTk0n8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)