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