UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VGTsZg+TUUBgiMpZZrrAw/S7TA6xpEtfnmbvANO7ITc='
WHERE
key_id = '8a7edd79c13a303e8f3b62c39550f18335a724293ba3ce177baa3c65c268b199'
AND (
token = 'VGTsZg+TUUBgiMpZZrrAw/S7TA6xpEtfnmbvANO7ITc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)