UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nN95/lLRmCaIinygTNnXTE1x8slCKbOw2u4i+LBH5DE='
WHERE
key_id = 'b913c06b6aa644fe9b317d9fefd0e4efe4107de6388b1f05f44c3b85d821684a'
AND (
token = 'nN95/lLRmCaIinygTNnXTE1x8slCKbOw2u4i+LBH5DE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)