UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5n94cagR3ZjAThfGrF9tuK1oKlRKjyXvlYqvsdRp7M0='
WHERE
key_id = '2c0ffb1b48c3f9245be5d0759f642359372173f51b6c871d0641197b00605f07'
AND (
token = '5n94cagR3ZjAThfGrF9tuK1oKlRKjyXvlYqvsdRp7M0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)