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