UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Nm1niVWeg3we9Y4sK6BLH8i+z/e5qOJ41MENVLBflzY='
WHERE
key_id = '1327e9490e1ef5481618bd461ab18dce021eb923ac01c731b5b5457658a474dc'
AND (
token = 'Nm1niVWeg3we9Y4sK6BLH8i+z/e5qOJ41MENVLBflzY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)